Gestor 41T1Ak1KcqlrCDGA4njsr9XEjYzZTyLda1r9zPtM4AfHEsHNTUvTccNDbczqAC1O5Nb171hR+vXqbdH44SXnRsJeZQ1IQJKMfBWlaHT4LF7EWvkJ1UqapMBu6IXlKetj38j1AtML8rx5ey0c Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados id,System.Int32 tipo,System.String valor_total,System.Decimal total_nota,System.Decimal razao_social,System.String data,System.DateTime 30 False dados Gestor SELECT mov.id, mov.data, mov.tipo, mov.valor_total, mov.total_nota, cor.razao_social FROM mov_estoque mov left join correntista cor ON cor.id = mov.fornecedor_id where mov.status = "Fechado" and CASE WHEN {Todos_os_ajustes} = 1 THEN mov.tipo = 'Ajuste' ELSE mov.tipo = '' END or CASE WHEN {Todas_as_compras} = 1 THEN mov.tipo = 'Compra' ELSE mov.tipo = '' END and DATE_FORMAT(CAST(mov.data as DATE), '%Y-%m-%d') between DATE_FORMAT(STR_TO_DATE('{Data.FromDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') AND DATE_FORMAT(STR_TO_DATE('{Data.ToDate.Date}', '%d/%m/%Y'), '%Y-%m-%d') order by mov.data ,versao,versao,Versão_x0020_do_x0020_Sistema,System.String,,False,False,False ,data_inicial,data_inicial,System.String,,False,False ,data_final,data_final,System.String,,False,False ,produto_id,produto_id,System.String,_x0030_,False,False ,grupo_id,grupo_id,System.String,_x0030_,False,False ,subgrupo_id,subgrupo_id,System.String,_x0030_,False,False ,familia_id,familia_id,System.String,_x0030_,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False ,agrupar_produtos,agrupar_produtos,System.String,,False,False ,tipo_mercadoria,tipo_mercadoria,System.String,,False,False ,vendedor_id,vendedor_id,System.Int32,_x0030_,False,False ,agrupar_por,agrupar_por,System.String,,False,False ,Data,Data,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM_x002C__x005F_x0038__x005F_x002F_8_x005F_x002F_2018_x005F_x0020_11:26:13_x005F_x0020_AM,False,False ,Todos_os_ajustes,Todos_os_ajustes,System.Boolean,false,False,False ,Todas_as_compras,Todas_as_compras,System.Boolean,false,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,8.4,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor v.{versao} - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 22.4,0.6,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 e765e1718f9b42739e82d794b7030864 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 24.6,1,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 f5777b5814fd4ba3ad34e073c29fca76 Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0.4,19,4.2 Transparent 0,3.6,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Código Black Expression Center Transparent 1.8,3.6,9,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 Fornecedor Black Expression Center Transparent 16.2,3.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 Right 0,0,0,0 Text10 Valor compra Black Expression Center GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 781d2eafa39f4cfd8624172f344d8295 Center 0,0,0,0 Text1 TOTAL DE COMPRAS / AJUSTES Black Expression 300f366621684f32953b76a2d6198877 Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 d087582087324b43b26b933783e54715 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 bb9274ce219d404b9b7c76e7c06192c3 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 08f13c99801d43d8a8d329504e224755 Right 0,0,0,0 Text18 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 6fb81d3b212e44629b8a45ea3312aead Right 0,0,0,0 Text19 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo 4c2d6b0c76e04a869266abd979183a20 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 a3d652b2a4424de8bdf396547c4df7b7 0,0,0,0 Text44 {descricao_filtros} Black Expression Center Transparent 13.6,3.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 0ac0cf4b438e42e2a01d80e7b7f4dfdf Center 0,0,0,0 Text9 Data Black Expression Center Transparent 10.8,3.6,2.8,0.6 Tahoma,8.25,Bold,Point,False,0 056414a604fa4a5296931be3ebcd440e Center 0,0,0,0 Text16 Tipo Black Expression Center ReportTitleBand1 Transparent 0,5.4,19,0.4 Transparent 0,0,1.8,0.4 Tahoma,8.25,Regular,Point,False,0 823f0e539bf34e6e9cb7e81069b3fee9 0,0,0,0 Text7 {dados.id} Black Expression Center Transparent 1.8,0,9,0.4 Tahoma,8.25,Regular,Point,False,0 db8253923816400da5eb4ac8cd73fb4b 0,0,0,0 Text8 {dados.razao_social} Black Expression Center Transparent 16.2,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 e52c597148f9466f868f815d9acf72f2 Right 0,0,0,0 Text12 {dados.total_nota} Black , . 1 False Expression Center Transparent 13.6,0,2.6,0.4 Tahoma,8.25,Regular,Point,False,0 87c402a41ac0495f9c3130e08df51483 Center 0,0,0,0 Text11 {dados.data} Black DataColumn Center Transparent 10.8,0,2.8,0.4 Tahoma,8.25,Regular,Point,False,0 589306b799eb4ba09f24de3cf3a68c6e Center 0,0,0,0 Text17 {dados.tipo} Black DataColumn Center 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black dados DataBand1 ASC data Transparent 0,6.6,19,0.8 Transparent 14.4,0.2,2,0.4 Tahoma,8.25,Regular,Point,False,0 fe836a0d4c6740aeb70ff8b11921ea01 Right 0,0,0,0 Text13 Valor total: Black Expression Center Transparent 16.4,0.2,2.6,0.4 Tahoma,8.25,Bold,Point,False,0 949cfc4fa2d64f75bf386fc03d9051d1 Right 0,0,0,0 Text15 {Sum(DataBand1,dados.total_nota)} Black , . 9 2 R$ Totals Center ReportSummaryBand1 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] Control Window 32,32,96,20 Microsoft Sans Serif,8 Black Short a7c7a4bcc2eb4955ab6cde4a0ba5af86 32, 32 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtInicial 96, 20 2/6/2018 4:30:02 PM Window 168,32,96,20 Microsoft Sans Serif,8 Black Short 2087dd10db564b3dabe2b8659e1572a1 168, 32 12/31/9998 12:00:00 AM 1/1/1753 12:00:00 AM dtFinal 96, 20 2/6/2018 4:30:08 PM Control 32,8,96,24 Microsoft Sans Serif,8 Black 111fc3783c724ebcbcf857beb5908fba 32, 8 LabelControl1 96, 24 Data Inicial Control 168,8,96,24 Microsoft Sans Serif,8 Black de88df2b281a471aa8f07ab4a1b5c075 168, 8 LabelControl2 96, 24 Data Final 32,136,96,24 Cancel Microsoft Sans Serif,8 Black 6c3cf1854d00406fad372515b17e3607 32, 136 btnCancelar 96, 24 Cancelar Data.From = dtInicial.Value; Data.To = dtFinal.Value; Todos_os_ajustes = tdAjustes.Checked; Todas_as_compras = tdCompras.Checked; 168,136,96,24 OK Microsoft Sans Serif,8 Black 97f51dccb0ac45afaa711d0ba0f9c951 168, 136 btnGerar 96, 24 Gerar Control True 32,72,232,24 Microsoft Sans Serif,8 Black fe9c83a2ce8745a2b8ec383ca7aaa78b 32, 72 tdAjustes 232, 24 Ajustes Control True 32,96,232,24 Microsoft Sans Serif,8 Black 1ede0500b98140eda5da45aca4042a75 32, 96 tdCompras 232, 24 Compras Microsoft Sans Serif,8 5d4d0cf488d64308b56087b76ba501c7 0, 0 periodo 304, 192 Informe o período System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 4/5/2019 2:33:35 PM 9/25/2015 9:37:43 PM Report.mrt 0a22c6b9aa2746c1887d480b76832be5 Report Centimeters 2015.1.0 CSharp